package source.table;

import source.kernel.DB;
import source.kernel.base.Table;

import java.sql.SQLException;
import java.util.List;

/**
 * @author Hai Thomson
 */
public class history_uint extends Table {
	public history_uint() {
		super("history_uint", "itemid");
	}

	public List fetchdata(String itemid, String dateline, String now) throws SQLException {
		String sql = "SELECT clock, itemid, value FROM history_uint WHERE itemid = ? AND clock > ? AND clock < ?";
		return DB.queryMapList(sql, itemid, dateline, now);
	}
}
